CREATE TABLE [dbo].[ordre_fabrication]
(
[id_ordrefab] [int] NOT NULL IDENTITY(1, 1),
[n_ordre_fabrication] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[date] [date] NULL,
[ofliecom] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[article] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[couleur] [int] NULL,
[pfex] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ndae] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[tissue] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[traitement] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[taille] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[qtereçu] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[datelivraison] [date] NULL,
[qted] [int] NULL,
[chaine] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cadence] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dateprev] [date] NULL,
[tissu] [bit] NULL,
[fourniture] [bit] NULL,
[pattronnage] [bit] NULL,
[observation] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[ordre_fabrication] ADD 
CONSTRAINT [PK_ordre_fabrication] PRIMARY KEY CLUSTERED  ([id_ordrefab]) ON [PRIMARY]
GO
